USE [SocialDatabase]
GO

/****** Object:  Table [dbo].[UserConnection]    Script Date: 03/12/2012 22:23:28 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[UserConnection](
	[userId] [varchar](255) NOT NULL,
	[providerId] [varchar](255) NOT NULL,
	[providerUserId] [varchar](255) NOT NULL,
	[rank] [int] NOT NULL,
	[displayName] [varchar](255) NULL,
	[profileUrl] [varchar](512) NULL,
	[imageUrl] [varchar](512) NULL,
	[accessToken] [varchar](255) NOT NULL,
	[secret] [varchar](255) NULL,
	[refreshToken] [varchar](255) NULL,
	[expireTime] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[userId] ASC,
	[providerId] ASC,
	[providerUserId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


